class CreateChurches < ActiveRecord::Migration
  def change
    create_table :churches do |t|
      t.string   :name, :null => false
      t.string   :address, :null => false
      t.string   :city, :null => false
      t.string   :state, :limit => 2, :null => false
      t.string   :zip_code, :limit => 10, :null => false
      t.string   :phone
      t.string   :url

      t.timestamps
    end
    add_index :churches, [:name, :address], :unique => true
  end
end
